USE [RD_SalesMart]
GO

/****** Object:  Index [PK_Sales_Star_PriceLedger]    Script Date: 05/24/2010 15:59:04 ******/
ALTER TABLE [dbo].[Sales_Star_PriceLedger] ADD  CONSTRAINT [PK_Sales_Star_PriceLedger] PRIMARY KEY CLUSTERED 
(
	[OrderNumber] ASC,
	[OrderTypeCode] ASC,
	[OrderNumberDocumentCompany] ASC,
	[LineNumber] ASC,
	[SequenceNumber] ASC,
	[OrderSuffix] ASC,
	[PriceHistoryAlternateKey] ASC,
	[PriceHistoryAlternateKeySource] ASC,
	[SubSequenceNumber] ASC,
	[Tier] ASC,
	[TargetApplication] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


USE [RD_SalesMart]
GO

/****** Object:  Index [IX_Adjustmentname]    Script Date: 05/24/2010 15:58:59 ******/
CREATE NONCLUSTERED INDEX [IX_Adjustmentname] ON [dbo].[Sales_Star_PriceLedger] 
(
	[AdjustmentName] ASC,
	[UnitOfMeasureAsInput] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_OrderNumberTypeLineNumber]    Script Date: 05/24/2010 15:58:59 ******/
CREATE NONCLUSTERED INDEX [IX_OrderNumberTypeLineNumber] ON [dbo].[Sales_Star_PriceLedger] 
(
	[SourceID] ASC,
	[OrderNumber] ASC,
	[OrderTypeCode] ASC,
	[OrderNumberDocumentCompany] ASC,
	[LineNumber] ASC,
	[UnitOfMeasureAsInput] ASC,
	[PriceAdjustmentKeyID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_SequenceNumber]    Script Date: 05/24/2010 15:58:59 ******/
CREATE NONCLUSTERED INDEX [IX_SequenceNumber] ON [dbo].[Sales_Star_PriceLedger] 
(
	[SequenceNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_290]    Script Date: 05/24/2010 15:58:59 ******/
CREATE NONCLUSTERED INDEX [missing_index_290] ON [dbo].[Sales_Star_PriceLedger] 
(
	[SequenceNumber] ASC
)
INCLUDE ( [SourceID],
[OrderNumber],
[OrderTypeCode],
[OrderNumberDocumentCompany],
[LineNumber],
[PriceAdjustmentKeyID]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


